/****************

state_import.do
--Imports and cleans state.dta to merge with ITA.dta

****************/

/*When this script is executed, Stata's working directory should be set to the Project/ folder*/

*import state unionization data

use "Data\InputData\state.dta", clear

drop state

rename state2 state

gen construction=0
replace construction=1 if sector=="Priv. Construction"

gen manufacturing=0
replace manufacturing=1 if sector=="Priv. Manufacturing"

gen private=0
replace private=1 if sector=="Private"

gen public=0
replace public=1 if sector=="Public"

save "Data\IntermediateData\state_clean.dta", replace